Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/vinstall.sql

Text File | 2000-05-26 | 2KB | 90 lines

/* RCSVER $Id: vinstall.sql,v 1.5 2000-05-08 16:49:36-05 jwp Exp $ */
/* *************************************************************************
*        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
*
* Name:         vinstall.sql
* Date:         02/15/00
* memo:         Randy Wood
* Description:  Install the views for reports.
* Changes:
************************************************************************* */
/* ---------------------------------------- */
/* Set the log file and set exit upon error */
/* ---------------------------------------- */
SPOOL C:\TEMP\SQLLOG2.TXT
WHENEVER SQLERROR EXIT 11 ROLLBACK
    /* Level 0 - No dependencies */
@vbatchadjust
@vbillcoins
@vbilljam
@vbusfboxgar
@vcbadjust
@vckcashbox
@vckprobehist
@vcuraccparts
@vcurstaterange
@vdailyriders
@vdayadjust
@veventslist
@veventspart1
@veventspart2
@veventspart3
@veventspart4
@veventspart5
@vfberror
@vjamsLoc1
@vjamssummary
@vlastprobe
@vmagsales
@vmonthlyriders
@vmrreconcile
@vprobedates
@vprobes
@vrpt4headers
@vrptfaremaps
@vshiftmoney
@vsurvey
@vtokctcashclose
@vtokctprorphans
@vtrips
@vtripsgrps

    /* Level 1 - Dependencies Level 0 */
@vallevents
@vbcsummary
@vbusNotProbed
@vcbcount
@vclosing
@vcscurdetail
@vcuraccDetail
@vjamsloc
@vjamsLoc1a
@vopenitems
@vprevinsert
@vprobing
@vsumcscurcnt
@vsumcuracc
@vsurveyAA
@vsurveyaa_rr

    /* Level 2 - Dependencies Level 1 */
@vbpmoney
@vbpmoneydet
@vbusprobedetail
@vvbpmoneydet

    /* Level 3 - Dependencies Level 2 */
@vbusprobe50
@vbusprobe5x
@vvbusprobedetail

    /* Level 4 - Dependencies Level 3 */
@vcboxcycle
/* ------------------ */
/* Close the log file */
/* ------------------ */
SPOOL OFF
COMMIT;
EXIT;